Release 10.1A: OpenEdge Data Management:
Database Administration

PROUTIL IDXFIX qualifier

Checks database records and indexes to determine whether an index is corrupt or a record has a missing or incorrect index. IDXFIX will also repair corrupted indexes.

proutil db-name -silent -C idxfix

Parameters

db-name

Specifies the database whose index you are checking.

silent

Indicates that repetitive messages are not sent to the screen or the log file.

With PROTUIL IDXFIX, you can specify whether to scan the database, the indexes, or both. The Index Fix utility displays the following menu:

Index Fix Utility             Select one of the following:             1. Scan records for missing index entries.             2. Scan indexes for invalid index entries.             3. Both 1 and 2 above.             4. Cross-reference check of multiple indexes for a table.             5. Build indexes from existing indexes.             6. Delete one record and its index entries.             7. Quit             Enter your selection:

Table 20–4 describes the options.

Table 20–4: PROUTIL IDXFIX options

Option	Action
1	Scans the database records for missing or incorrect indexes.
2	Scans the index for corrupt index entries. You can specify whether to scan all indexes or a specific set of indexes.
3	Checks the index entries, then checks the database entries.
4	Prompts you for the table and indexes for which you want to run a cross-reference check. Allows you to choose two or more indexes from one table. It first scans them for invalid keys, then scans them for invalid records.
5	Prompts you to specify the table and the index that you want to use as the source from which to build the index.
6	Prompts you to specify the recid of the record you want to delete. Deletes one record and all its indexes from the database. Use this option when a record has damaged indexes.
7	Ends the PROUTIL Index Fix utility.

Notes

PROUTIL IDXFIX performs the following operations for each index it checks:
Reads the contents of the index and the contents of the file, verifies that all the values in the records are indexed, and verifies that each value in the index is in the associated record.
Performs various checks on the data structures in the index to verify that there is no corruption.
IDXFIX displays error messages on the screen and logs them in the log file. It also displays and logs a success or failure indication, along with the number of errors and warnings issued. IDXFIX might also display warning messages. Although these messages indicate that some condition is a problem, the index is still valid. Check the log file for details.
Index Fix does not provide a comparison of the index scan and the database scan when you run them online because the database can change during operation.
Index Fix is designed to wait if a record is in the process of being updated, thus ensuring that it does not incorrectly change a user action in process. However, because changes can occur during the scans, the reported data might not exactly match the database at completion. Index Fix displays this warning when you run it online.
You can run IDXFIX online or offline. However, to run Index Fix online, it must be run as a self-service session.
Index Fix does not delete or disable indexes, but when you run a full database scan with fix offline and it is successful, it enables a disabled index if no errors are found.
Enabling indexes online is not advisable because it is not possible to detect changes that are being made to indexes while the process is running.
While IDXFIX can ensure that an index is complete and correct, it cannot make any improvement to the index’s utilization level.
The _UserStatus virtual system table displays the utility’s progress. For a description of how to monitor the progress of this utility using the _UserStatus Virtual System Table (VST), see Chapter 14, " Maintaining Database Structure."